<?php
require_once('configure.php');
ini_set("display_errors",1);  
list($nik,$nama) = explode("/" ,$_GET['q'] );
$query = "
	SELECT b.nama,a.nik,a.karyawan_id FROM  karyawan a
	INNER JOIN biodata b ON a.biodata_id = b.biodata_id
	WHERE  a.nik LIKE '{$_GET['q']}%'  AND a.karyawan_id NOT IN ( select karyawan_id FROM karyawan_disable )
	AND a.karyawan_id NOT IN (select karyawan_id FROM pemberhentian ) 	
";
 
$res = my_query($query);
 
while( $rw=my_fetch_array($res) ){
echo strtoupper($rw['nik']."/".$rw['nama'])."\n";
}
exit;
?>